Export Transformer

The transformer process "transforms" the information in the staging table into an ASCII file that can be imported into the two financial systems: Deltek GCS Premier and Deltek Costpoint 6x or higher.

The transformation process is executed at the end of the export step.

In order for the transformation process to occur, you must place a file named ExportExpense.properties in the directory specified in the Export Location field on the General Options tab of the General Configuration screen. This file contains information for the type of transformer that will be executed.

The valid values for transformation are COSTPOINT7X, COSTPOINT6X, and GCS. There should be at least one line in the ExportExpense.properties file. The format of the line is as follows:

• EXPORT=COSTPOINT7X
• EXPORT=COSTPOINT6X
• EXPORT=GCS

  In addition to specifying the layout of the transformed ASCII file, you can space out one or more of the User-Defined Table (UDT) fields by placing the following parameter in the properties file: EXPORT_UDTXX=N.

  For example, if you want UDT03 to be removed from ASCII file so the destination system can provide a default, use "EXPORT_UDT03=N."

Note: The program creates the ASCII file in the Export directory. The name of the file is "<Batch ID>.exp." When the transformation is completed, the export staging tables are cleared for the selected batch ID.

Attention: Review the "Transformed Export ASCII Layouts" chapter in the Deltek Time & Expense with ESS Technical Guide for information on the ASCII file layouts.